/*
Navicat MySQL Data Transfer

Source Server         : canonlife
Source Server Version : 50538
Source Host           : localhost:3306
Source Database       : canonlife_pre

Target Server Type    : MYSQL
Target Server Version : 50538
File Encoding         : 65001

Date: 2014-07-17 11:04:27
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tb_plugins
-- ----------------------------
DROP TABLE IF EXISTS `tb_plugins`;
CREATE TABLE `tb_plugins` (
`plugid`  int(11) NOT NULL AUTO_INCREMENT ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`config`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`show`  int(2) NOT NULL DEFAULT 1 ,
`static`  int(2) NOT NULL DEFAULT 0 ,
`iconname`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`plugid`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=35

;

-- ----------------------------
-- Records of tb_plugins
-- ----------------------------
BEGIN;
INSERT INTO `tb_plugins` VALUES ('1', 'contact', '{\"plugid\":1,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoCtcEditTl\",\"count\":0,\"sort\":7,\"default\":1,\"alwayshow\":1,\"name\":\"contact\"}', '1', '0', ''), ('2', 'form', '', '0', '0', ''), ('3', 'gallery', '{\"plugid\":3,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoGalEditTl\",\"count\":0,\"sort\":8,\"default\":1,\"alwayshow\":0,\"name\":\"gallery\"}', '1', '0', ''), ('4', 'image', '{\"plugid\":4,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoImgEditTl\",\"count\":0,\"sort\":3,\"default\":1,\"alwayshow\":1,\"name\":\"image\"}', '1', '0', ''), ('5', 'map', '{\"plugid\":5,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoMapEditTl\",\"count\":0,\"sort\":5,\"default\":1,\"alwayshow\":1,\"name\":\"map\"}', '1', '0', ''), ('6', 'price', '{\"plugid\":6,\"show\":1,\"icon\":0,\"position\":1,\"allowmobile\":1,\"count\":1,\"sort\":1,\"default\":1,\"alwayshow\":1,\"name\":\"price\"}', '1', '1', ''), ('7', 'startdate', '{\"plugid\":7,\"show\":1,\"icon\":0,\"position\":1,\"allowmobile\":1,\"count\":1,\"sort\":2,\"default\":1,\"alwayshow\":1,\"name\":\"startdate\"}', '1', '1', ''), ('8', 'text', '{\"plugid\":8,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoTxtEditTl\",\"count\":0,\"sort\":4,\"default\":1,\"alwayshow\":0,\"name\":\"text\"}', '1', '0', ''), ('9', 'upload', '{\"plugid\":9,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoUlEditTl\",\"count\":0,\"sort\":9,\"default\":1,\"alwayshow\":1,\"name\":\"upload\",\"config\":{\"allow\":\"*\",\"accept\":\"\"}}', '1', '0', ''), ('10', 'vdo', '{\"plugid\":10,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoVdoEditTl\",\"count\":0,\"sort\":6,\"default\":1,\"alwayshow\":0,\"name\":\"vdo\"}', '1', '0', ''), ('11', 'trip', '{\"plugid\":11,\"show\":1,\"icon\":0,\"position\":1,\"allowmobile\":1,\"count\":1,\"sort\":3,\"default\":1,\"alwayshow\":1,\"name\":\"trip\"}', '1', '1', ''), ('12', 'thumbnail', '{\"plugid\":12,\"show\":1,\"icon\":0,\"position\":2,\"allowmobile\":3,\"count\":1,\"sort\":0,\"default\":1,\"alwayshow\":1,\"name\":\"thumbnail\"}', '1', '1', ''), ('13', 'hashtag', '{\"plugid\":13,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoHshEditTl\",\"count\":0,\"sort\":9,\"default\":1,\"alwayshow\":1,\"name\":\"hashtag\"}', '1', '0', ''), ('14', 'imagewidth', '{\"plugid\":14,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoImgEditTl\",\"count\":0,\"sort\":3,\"default\":1,\"alwayshow\":1,\"name\":\"imagewidth\"}', '1', '0', ''), ('15', 'reservation', '{\"plugid\":15,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoRsvEditTl\",\"count\":1,\"sort\":4,\"default\":1,\"alwayshow\":1,\"name\":\"reservation\"}', '1', '0', ''), ('16', 'newtrip', '{\"plugid\":16,\"show\":1,\"icon\":0,\"position\":1,\"allowmobile\":1,\"count\":1,\"sort\":3,\"default\":1,\"alwayshow\":1,\"name\":\"newtrip\"}', '1', '1', ''), ('17', 'comment', '{\"plugid\":17,\"show\":1,\"icon\":0,\"position\":9,\"allowmobile\":1,\"iconname\":\"icoTxtEditTl\",\"count\":1,\"sort\":4,\"default\":1,\"alwayshow\":1,\"name\":\"comment\"}', '1', '1', ''), ('18', 'buttonlink', '{\"plugid\":18,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoBtnEditTl\",\"count\":0,\"sort\":7,\"default\":1,\"alwayshow\":1,\"name\":\"buttonlink\"}', '1', '0', ''), ('19', 'formdata1', '{\"plugid\":19,\"show\":1,\"icon\":1,\"position\":1,\"allowmobile\":1,\"count\":1,\"iconname\":\"icoFrmEditTl\",\"sort\":19,\"default\":1,\"alwayshow\":1,\"name\":\"formdata1\"}', '1', '1', ''), ('20', 'vdoupload', '{\"plugid\":20,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoVdoEditTl\",\"count\":0,\"sort\":9,\"default\":1,\"alwayshow\":1,\"name\":\"vdoupload\",\"config\":{\"allow\":[\"mp4\"],\"accept\":\"video\\/mp4\"}}', '1', '0', ''), ('21', 'poll', '{\"plugid\":21,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoPollEditTl\",\"count\":0,\"sort\":9,\"default\":1,\"alwayshow\":1,\"name\":\"poll\"}', '1', '0', ''), ('22', 'reservationregister', '{\"plugid\":22,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoRsvEditTl\",\"count\":0,\"sort\":9,\"default\":1,\"alwayshow\":1,\"name\":\"reservationregister\"}', '1', '0', ''), ('23', 'questionnaire', '{\"plugid\":23,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoQustEditTl\",\"count\":0,\"sort\":9,\"default\":1,\"alwayshow\":1,\"name\":\"questionnaire\"}', '1', '0', ''), ('24', 'discount', '{\"plugid\":24,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoDiscountEditTl\",\"count\":1,\"sort\":9,\"default\":1,\"alwayshow\":1,\"name\":\"discount\"}', '1', '1', ''), ('25', 'bookupload', '{\"plugid\":25,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoZavEditTl\",\"count\":1,\"sort\":9,\"default\":1,\"alwayshow\":1,\"name\":\"bookupload\"}', '1', '0', ''), ('26', 'worktracker', '{\"plugid\":26,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoFcltEditTl\",\"count\":0,\"sort\":10,\"default\":1,\"alwayshow\":1,\"name\":\"worktracker\"}', '1', '0', ''), ('27', 'bookdata', '{\"plugid\":27,\"show\":1,\"icon\":0,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoFcltEditTl\",\"count\":0,\"sort\":3,\"default\":1,\"alwayshow\":1,\"name\":\"bookdata\"}', '1', '1', ''), ('28', 'cuisinedata', '{\"plugid\":28,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoCookEditTl\",\"count\":0,\"sort\":12,\"default\":1,\"alwayshow\":1,\"name\":\"cuisinedata\"}', '1', '0', ''), ('29', 'pricefull', '{\"plugid\":29,\"show\":1,\"icon\":0,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoPriceTl\",\"count\":0,\"sort\":3,\"default\":1,\"alwayshow\":1,\"name\":\"pricefull\"}', '1', '0', ''), ('30', 'uptime', '{\"plugid\":30,\"show\":1,\"icon\":0,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoPriceTl\",\"count\":0,\"sort\":3,\"default\":1,\"alwayshow\":1,\"name\":\"uptime\"}', '1', '1', ''), ('31', 'texteditor', '{\"plugid\":31,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoTxtEditTl\",\"count\":0,\"sort\":3,\"default\":1,\"alwayshow\":1,\"name\":\"texteditor\"}', '1', '0', ''), ('32', 'newtour', '{\"plugid\":32,\"show\":1,\"icon\":0,\"position\":2,\"allowmobile\":1,\"count\":1,\"sort\":3,\"default\":1,\"alwayshow\":1,\"name\":\"newtour\"}', '1', '0', ''), ('33', 'copy', '{\"plugid\":33,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":1,\"iconname\":\"icoTxtEditTl\",\"count\":0,\"sort\":3,\"default\":1,\"alwayshow\":0,\"name\":\"copy\"}', '1', '0', ''), ('34', 'reservationregistercanon', '{\"plugid\":34,\"show\":1,\"icon\":1,\"position\":2,\"allowmobile\":0,\"iconname\":\"icoRsvEditTl\",\"count\":0,\"sort\":9,\"default\":1,\"alwayshow\":1,\"name\":\"reservationregistercanon\"}', '1', '0', '');
COMMIT;

-- ----------------------------
-- Auto increment value for tb_plugins
-- ----------------------------
ALTER TABLE `tb_plugins` AUTO_INCREMENT=35;
